SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54448 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54448 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659440,286353,784912,886335,499682,260072,802425,882879,434421,471073,291575,1031378,1029512,279976,240325,840967,854611,1043802,871958,472948,987062,623004,860675,879942,693185,833937,67946,521185,558106,576324,891429,426237,647490,701272,1027896,357102,334388,368114,138896,843445,522120,133067,24883,43226,871368,940608,570880,18126,649646,946952,499836,594932,853238,82127,111102,176496,753559,991991,430234,944204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]