SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195979 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195979 [ RunTime:0.002958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636408,583874,853776,378231,70253,441395,847436,1023027,1020812,290912,104885,66055,274358,527302,470418,277258,414808,123362,731699,86815,228747,936406,170912,383062,423993,478396,376196,196854,877035,863912,671015,606004,408134,268514,193663,1006994,1004045,644066,41601,384898,715701,94014,781104,328983,541652,9625,1031991,1003916,645583,221587,187946,514818,872224,35850,991845,888436,1014965,174940,282588,488026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]