SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563328 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563328 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029310,652834,39305,703441,852575,609871,1022242,331010,952789,631068,74152,287708,521213,410176,1041869,14263,173778,784423,266074,168936,701681,1041850,405108,325802,562717,891803,5862,1006317,574784,657049,238423,870825,217423,630199,73509,57676,778208,337637,141103,136573,251374,553124,137656,911335,804819,654918,901838,1031504,537007,21899,573196,793794,875210,13872,67434,988619,80370,111858,821002,336650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]