SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807243 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807243 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462052,672901,1009502,835698,203531,209675,203938,149849,334190,818931,779910,403243,911308,1048406,443807,827960,290599,892335,992106,155186,815636,151110,525295,157514,785604,667266,811076,865840,813735,437941,692255,959971,106735,575622,527034,1000938,799285,479149,883435,9770,833293,231285,166652,677217,222595,804099,272574,251767,694232,544063,324790,466462,471760,83792,592552,474725,967235,923229,46004,946903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]