SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335003 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335003 [ RunTime:0.005006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881005,79558,546982,210261,333211,934417,166955,508303,1027650,251603,550351,717758,659291,164872,424009,204404,179729,449634,682692,954021,20132,857012,266198,952604,1013388,934618,1013013,354603,228323,1048827,174219,524184,895144,740036,498615,564400,267548,475116,378999,574021,213481,963125,566167,643531,824230,141796,505463,197307,701935,1023719,631398,374596,516618,737253,100732,448294,129494,469479,135482,809992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]