SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498801 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498801 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196360,1018248,778676,1003129,273623,453778,263427,770840,614590,773165,684579,74062,202469,315433,731498,324574,175970,295321,280141,453569,32633,801391,506547,964067,754986,342782,821665,535843,839470,879026,546783,986524,719263,240069,71011,713593,870381,614786,499732,472798,92367,331488,58685,957001,455830,23932,172183,132562,1033421,72145,827947,393481,1033331,310333,702568,255693,799258,72036,823989,425148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]