SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431417 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431417 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504181,757664,61987,744460,552309,217330,527121,636025,771441,109333,407728,477310,322997,654430,405688,604897,33211,1002818,751417,815247,363782,359550,456323,684926,925452,710465,221388,606557,316513,507051,191584,805482,715658,786643,389297,867883,132962,657232,620279,867092,907910,450805,802091,443202,539200,736735,720718,15019,39506,781001,493041,365299,1007371,893104,201147,384943,410995,254525,956077,239787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]