SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011685 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011685 [ RunTime:0.004537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819883,180609,507113,398495,949476,821877,111819,210997,890385,307621,778197,1007710,222800,454704,944974,902289,640818,986807,221680,541046,58561,196030,972009,769673,773114,328365,231285,464888,764187,590184,932788,1031669,466281,32564,728144,823489,339224,564417,764847,281418,904308,333887,435461,294903,608851,1019235,336474,247848,1012743,996692,644672,423408,146610,723473,850349,1030559,59001,266332,241133,532652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]