SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584417 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584417 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742072,706913,1011051,598711,274361,1036932,492912,270585,490406,426830,474598,724317,17159,858121,264053,769759,997223,302308,840374,46937,95207,824265,617812,619645,538640,751533,440141,962680,256029,641116,845528,664042,523183,832823,90734,318590,149526,454572,448590,135020,8273,37484,855604,87358,872685,850126,665722,308435,336915,391109,309595,984841,828652,392995,207852,854248,1036342,137952,303890,447366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]