SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531948 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531948 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876054,178366,107095,633528,324309,527087,611574,570408,524066,512773,832922,780408,667602,748743,212982,671794,815530,965492,928681,726956,16930,307168,177802,858778,455867,435269,321974,330612,456052,882097,502799,602957,326114,737819,434862,62014,382857,442444,695164,358926,911585,798673,815852,60183,128018,395586,405129,521364,381433,871382,1046101,893013,1034486,779773,42606,167067,354674,602656,764375,234341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]