SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513818 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513818 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757255,185578,452046,1014132,33418,319244,792739,542512,786416,996287,374411,1000799,536251,626067,807778,210434,962103,947646,979086,984291,539578,150799,29691,971708,398334,799624,299817,67838,289044,462269,527120,229550,750959,675058,272744,293952,333576,826176,582425,925242,344730,1015929,247395,336702,429517,298030,225789,1010453,247749,173364,80172,46680,587684,727840,687970,937646,744400,268812,418468,300597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]