SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356926 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356926 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590592,461940,730913,104058,374404,369577,577189,522487,558496,616744,875013,63495,313663,19986,657273,615707,479212,246075,367924,129301,321281,1038893,960141,388564,253513,218444,720724,974230,297595,233745,267671,25075,127874,834873,240507,827398,373081,715735,391709,715763,370240,269923,693208,211898,84438,516999,76945,330879,493531,447210,756740,605066,509140,880704,491230,194529,931162,887366,405121,699530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]