SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485701 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485701 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508408,832352,281211,352822,362105,757173,945884,35684,624463,559550,773544,435787,839438,886621,565861,205670,970074,758484,445657,751813,226061,477227,511646,1043333,822264,1000957,316971,523679,42916,596427,987036,377612,405027,808957,991103,931749,264257,656045,416415,916660,6348,785424,605869,815048,996274,56185,31970,988662,706169,104597,456088,306179,275379,177779,387348,97059,478160,906113,418853,614320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]