SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315628 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315628 [ RunTime:0.004219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937413,41142,732911,678757,1046188,585733,734036,401309,855680,946425,582462,524847,461778,211226,985671,944897,139398,674186,172235,926778,290079,529894,107976,749819,819470,66822,757308,270565,181482,1041645,595879,379307,758272,41241,966485,391417,528201,961931,204213,129789,910863,804290,431339,609170,803461,672661,95619,855841,666382,232092,181932,190001,806167,275324,830331,423175,938169,798296,186777,1037324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001269s ]