SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431510 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431510 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004368,805214,908006,716920,424042,958053,644662,648169,611085,557279,507168,434588,576906,940028,110181,28781,780651,70630,622542,249612,944627,920438,775066,889344,456459,238835,179695,564167,539486,715355,915827,428846,774036,885451,235477,780419,68767,308030,301754,253898,612863,430925,19824,489129,755276,912688,532521,487467,843846,258403,888266,986269,1016948,606506,669876,963965,543421,697008,328625,918977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]