SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027874 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027874 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572829,765870,982669,121810,719888,766057,544510,290936,874759,895898,666747,489938,133415,85279,822020,1034189,501272,1000176,990926,152746,196950,1040627,364275,899708,428214,122527,585531,939790,677525,430594,362032,490455,1001837,705247,630767,784489,974869,177850,394611,640644,637613,889816,790278,81628,840200,280498,120526,466188,36735,223549,137317,921012,100236,684018,967881,943184,914504,320231,45153,960179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001064s ]