SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505230 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505230 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622589,1011998,145983,17763,580537,376100,458809,219597,436086,835522,477722,1043460,785478,1038804,919739,825213,18045,403341,882876,68020,950718,69476,99518,733472,400160,887649,234770,19018,97554,83380,556713,262958,437265,819253,180882,904391,157330,2177,606672,592223,728266,508347,441038,710350,440411,535357,999148,861747,427947,225282,338633,493533,920459,486028,612369,195924,21693,727377,656708,651023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001609s ]