SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575746 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575746 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255786,758514,809022,17321,454528,233665,888123,938397,168447,283123,730989,434797,25421,503872,1041692,792941,74145,752977,154114,539288,455276,56477,710166,755790,156099,736362,25437,197007,287298,575927,39232,217136,1022501,946710,51562,655389,218729,942017,171645,411173,678296,279501,6867,125476,100843,164684,644553,230275,549720,875552,598156,1034510,525354,1048183,459288,179595,698731,227462,104966,156852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]