SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531051 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531051 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566866,835899,760416,293501,847605,828320,590532,101273,419424,857077,169401,430787,95765,333686,9257,1022399,733646,964464,307259,883293,313844,517836,549332,728813,24014,737515,583580,809102,57167,404553,267477,117456,500640,763354,85927,833848,471037,113779,164584,464256,617086,627220,549100,653336,618722,715472,685803,691354,220563,195293,96803,154775,161604,860579,572059,71447,221255,267491,531974,911915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]