SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432106 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432106 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343712,726820,823963,230795,1023140,247903,684208,983985,464977,753027,978886,783793,931049,763213,926547,762161,402649,945607,469777,349640,679838,263612,503672,455517,246885,96953,845342,749966,565604,559045,287230,397094,225468,112838,89242,765792,1009916,602540,772376,846731,490057,1007870,720362,670873,74831,489205,990144,61249,1017478,899622,155777,941177,392583,544776,946573,603041,104134,2414,492677,513760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]