SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415694 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415694 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943603,981289,518187,357209,389090,27057,886046,603347,417833,315963,913502,424143,598235,382966,81315,474965,473653,59962,286164,815898,752238,1042373,496974,905250,59094,643051,414527,154006,678879,203552,631680,890775,669830,113316,69353,392218,442116,5772,204664,754044,454328,436543,200104,277,571396,1027559,897445,215518,116338,112635,427717,479668,727312,1000836,877712,747253,1014392,443020,316888,435007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000942s ]