SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429989 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429989 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624304,95784,920532,623657,959966,862247,1005503,788259,425961,123742,902217,137953,1038481,530356,230828,282795,900816,364065,565388,229882,418132,764194,24354,1015147,1038587,975874,348345,430288,569901,50681,130560,512845,767775,717585,276873,432187,702053,459983,568613,98273,37857,155788,560670,94116,913455,756502,851321,95578,784055,817150,31121,421877,259891,967718,681702,874274,328570,795312,479611,97438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001153s ]