SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401944 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401944 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180812,186420,675700,262133,360497,601894,425481,927536,512053,777972,467668,874897,212001,791251,537313,64900,240215,813114,835046,712413,386788,728014,57680,876948,391083,342522,897540,616756,435228,426052,949004,675226,93268,463950,1016892,637318,115782,820819,970971,794190,592548,876390,800266,124502,569366,526206,747717,21817,201773,990138,804636,882133,214219,187157,694994,435491,717812,892738,901868,644678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]