SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506517 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506517 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491060,101784,10116,368585,761098,217834,977217,512811,160295,1034208,101806,873810,890068,336486,800607,1001954,401639,664079,82443,643087,331392,1048677,154967,279626,392800,434643,316690,269913,814197,103304,327675,631580,923605,221181,950374,802396,697866,76463,195886,631370,221906,12648,666540,606509,329617,977986,445986,485393,802894,905878,98663,361275,274522,927011,834507,604309,335771,649423,378078,299490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]