SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56440 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56440 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615582,713681,676978,33435,851180,102688,1032604,605280,621634,563286,224814,551009,857216,370716,135320,488401,796208,375716,83225,394689,620291,229048,396327,95797,1015781,422,282525,828280,471780,472556,566490,647874,499245,774086,610152,460868,753227,706191,697987,332349,515951,872951,104930,110797,963617,353874,870829,967277,783094,443016,778780,154178,66718,666508,779236,994348,278105,424000,553695,853075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]