SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506148 LIMIT 1 [ RunTime:0.000748s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506148 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40731,896888,668596,560197,58765,797631,405599,829701,716755,1022212,88829,545284,599167,190837,297875,685944,981502,428882,448496,719424,609272,267002,821217,114166,907612,682101,138785,51289,704942,787836,310092,930126,862042,786107,5890,36161,192458,775064,198017,760063,470773,8282,444955,35351,160920,617126,404454,329508,1018606,987737,728624,583603,919471,290611,631867,317237,900146,506386,990316,144385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]