SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11178 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11178 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14471,534017,620258,913767,357983,778432,180466,837434,840839,505779,314266,870089,684436,505542,517561,955128,674588,762703,94015,550383,238644,955842,391991,2244,141011,279131,927193,176580,281439,938565,754974,224572,275044,155786,792985,266701,368911,84559,856537,886803,584440,935790,842377,949385,80198,319016,642037,544178,631492,839624,167024,782224,757067,435938,426355,433377,744264,766628,155469,962967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]