SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012651 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012651 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755409,579818,586789,607429,922222,905080,740372,582068,52266,200953,254945,398482,552065,388886,951895,779553,277947,146078,247862,1007934,915547,1039558,186762,1026254,134850,948147,45910,390595,307457,203607,203817,473111,496172,907189,968035,418414,934541,407322,574619,722728,626848,602976,901622,360114,16093,937912,676456,545725,4078,280966,523617,991680,766060,841769,48960,208326,458527,668003,172690,222428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]