SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306621 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306621 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713314,454521,456188,1024339,226893,317079,104804,348193,920675,588496,258931,523607,924029,665556,261698,544212,750770,572810,321032,666676,199851,766496,86423,1020485,443685,336926,959945,86418,412476,340317,794223,1012396,120738,698109,291874,379551,478087,362974,334536,572625,150240,215432,565871,618580,499792,717817,450836,438209,89355,789390,717975,621403,117541,144804,150125,971332,181935,646020,248342,225909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]