SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100313 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100313 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731706,840080,85445,808845,348184,627996,570531,774207,898516,782750,979013,269762,247870,817384,79257,412025,410834,793788,437363,772558,399606,321089,580254,252156,695140,838515,268619,640063,489729,964525,283786,80775,821337,74805,226636,999685,322203,195234,496320,929079,19672,1021959,761020,207347,741334,98889,624539,776915,860939,866840,590647,819967,744077,947463,450230,798329,762936,753763,476858,599219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]