SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510822 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510822 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814903,403416,1001192,407044,121812,982730,360139,746273,405819,58035,671903,929849,448740,815972,100487,875715,772221,562106,155874,182128,210892,189792,421554,417296,491797,943895,928579,876070,894171,60511,846255,886611,631200,674281,794216,206060,480640,795530,311179,618519,399057,439167,637314,961589,1042284,1041456,772771,868609,549858,299292,79605,767696,674058,235713,96963,534155,101864,375996,712123,59645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]