SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419273 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419273 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220307,686669,392131,549076,126847,931451,1024512,762643,1016098,33133,712996,963106,65131,800652,905727,181499,752432,811311,490397,200930,758886,103068,500576,165211,75171,89079,123049,711423,573016,686350,64728,394404,56191,895868,953100,696325,336121,151971,889851,98967,953185,185622,425474,906870,498448,507924,679974,301537,43877,400619,836269,385349,985195,449065,51245,420967,93558,326837,178062,90963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]