SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000230 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000230 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226592,1037702,469176,685030,321331,443833,359367,118711,306630,191800,499575,114133,396727,284092,543114,328765,687067,208240,520193,928613,341356,690817,562545,425169,9987,333461,259798,54894,642564,243436,554751,539646,115853,606731,352396,998009,662010,734243,963302,1047098,867964,940368,405023,1020263,30376,467692,245182,807691,637689,700717,137138,1010706,219625,777340,15015,37616,147820,571708,223507,306039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]