SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473646 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473646 [ RunTime:0.003115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317535,810919,760868,828019,394543,281358,540431,712075,389155,671058,463081,85014,805604,230885,982059,358797,665522,907503,769866,131569,763769,370878,425706,60483,906689,382403,234804,129346,371933,181441,11769,400775,53890,77191,1003512,221537,976393,521731,385506,73042,234887,944329,170946,233412,941237,706940,704460,894748,210619,68350,531489,851162,859893,74668,801475,290145,1000131,369018,604297,565277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]