SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563908 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563908 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321168,245566,706215,733058,639488,724518,84188,96751,340266,998508,928663,243701,990774,40676,937983,345967,378775,780265,824135,516683,640396,379126,106729,99652,395797,403696,591046,57073,815267,28086,130003,997926,379500,394430,760504,600897,963862,773820,70635,342566,698113,332014,763811,276568,876951,394960,104505,642594,12502,869812,58312,691622,729390,743878,247590,682612,807201,989748,760868,742829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]