SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46685 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46685 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382828,336524,757787,301917,49583,735405,390016,111515,376548,561212,510915,385285,601465,108819,957073,376016,259291,753409,905812,938800,46571,452842,459216,911840,448146,179105,562729,302309,108991,815326,408232,563539,974310,312456,260577,856972,465420,788111,384373,756131,989569,493207,189126,344124,1036670,920316,240958,624729,506309,272328,336657,922458,105740,317267,529005,536989,16741,486427,764513,728282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]