SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002915 LIMIT 1 [ RunTime:0.005546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002915 [ RunTime:0.003630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762353,28084,282382,448657,170581,567604,271528,974798,900162,244034,204512,63525,58301,669315,418391,929196,25883,193621,113729,536159,857945,1043916,2748,152348,895214,90728,194946,898812,620260,64636,30188,852627,320702,1015482,576179,977657,808163,341684,395841,1000787,701255,976738,1007234,13819,949847,261373,178813,201808,616700,915865,830185,864909,487216,775035,610825,1010819,969815,764120,737539,379817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000821s ]