SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513380 LIMIT 1 [ RunTime:0.000757s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513380 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230809,541115,307567,509388,33679,494041,525982,435111,119294,32352,549362,653268,348638,892041,340353,736214,81854,893430,217809,799860,239713,430616,117476,607247,455981,199749,1004880,355270,106161,60715,227089,919119,639458,366992,879980,443836,744435,354480,489045,770784,646799,733345,17409,607449,640278,356489,1045832,929777,581647,643556,740142,11988,277471,155668,86313,35180,99787,739699,362815,165469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]