SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497194 LIMIT 1 [ RunTime:0.000872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497194 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547012,787528,1010271,701418,154105,393813,450054,264516,625460,773871,83601,988918,658328,106126,783749,366739,777859,384988,834565,332689,686553,1811,679200,313934,621444,939853,612482,564717,975802,461245,469785,1034482,144844,875389,244429,140809,959260,214710,868116,395369,899025,91492,250284,974729,834468,328170,968401,578402,483093,991681,11953,373191,441772,598502,397730,690512,587724,73808,881808,108718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001170s ]