SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023224 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023224 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73961,431424,193450,1014558,722895,42621,983767,536652,731060,1040713,552011,211044,693626,586515,830031,454654,264464,807095,414123,216163,1039930,334088,590549,980292,165750,567660,126987,756614,604027,767187,865150,194018,918006,972797,451811,980475,542758,360503,1017058,229287,406062,826052,920016,146667,650210,97011,209943,59986,529455,663786,312063,252472,559644,141123,231251,825388,327098,711141,503315,649225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]