SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319008 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319008 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242842,130889,560786,1023526,568731,406783,32924,249902,806879,685201,621784,16452,527935,298058,82343,563856,556534,930958,643263,886143,101841,663169,897836,558656,580608,815473,1034272,808018,64382,700961,704380,601538,1035648,223163,22944,11389,17674,787915,260927,866151,395439,807034,904250,863756,837097,694625,646183,32281,115454,112121,849386,507302,106219,334215,405737,664818,69850,862150,1038509,23730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]