SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419671 LIMIT 1 [ RunTime:0.003665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419671 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367230,206848,849346,272159,488870,919088,731984,512464,1010569,836350,260732,72069,192150,659343,319711,700906,736882,184724,994248,108184,115375,379082,441528,74687,322190,294481,487562,6942,425868,469691,450323,657968,912636,1011917,938639,138452,176140,1026266,397019,348553,852859,525443,270655,393554,528441,462128,151276,311725,610151,328259,68,1032368,337766,252783,96989,172851,604635,378530,510438,41783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]