SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 130015 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 130015 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442273,178646,800212,496183,537439,614029,1022210,409148,1011569,633286,921565,711209,969988,184028,37546,373485,1014793,356797,600370,56974,417406,554896,627389,107500,850790,129875,864280,932534,59817,474980,206689,599551,838594,158857,995550,279927,681686,33925,776305,453249,1025170,543688,169587,811191,412613,249162,181504,843178,486449,930462,935696,837534,140951,786927,191796,836872,126801,731035,646991,284946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 130015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 130015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]