SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568510 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568510 [ RunTime:0.003260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962857,939159,594156,265276,832630,91504,35718,210883,939500,475388,746692,156604,485621,315445,427558,797450,353926,72839,89885,1005652,847471,311853,962379,737924,324903,136367,757941,144167,830765,485133,1046725,282901,480116,820032,843511,316311,218089,859883,62968,662005,926234,168115,596231,719421,892240,646743,82717,238451,1006029,449044,8274,453575,495338,249677,645792,524310,31498,881535,463548,430935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001692s ]