SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397400 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397400 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105469,1048418,625999,633531,407561,466573,333092,331526,489366,1040086,64972,364485,18767,1005038,702728,906702,836006,425666,139236,62913,632968,954951,556644,568176,179531,111838,125943,808907,41187,1032210,47644,773569,539644,280146,237858,19678,780141,1039666,419845,871402,173111,963375,587819,791091,124487,680263,876125,159502,450943,333391,289713,502334,604981,588218,287205,977058,266452,849069,382051,758282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]