SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498571 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498571 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717442,425234,814682,687306,932474,598163,457251,991632,551101,911372,371967,439463,693382,656138,177666,495210,872547,815199,213656,354129,147398,732872,602456,371858,363510,247840,490966,107756,262340,518509,251769,376024,714243,952738,28862,970093,803836,892141,377281,487572,712721,872078,1042741,229388,513692,886816,296022,907826,574725,58870,200768,257983,736254,658217,113011,56989,155964,258964,443844,482427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]