SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316686 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316686 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400946,770329,200050,42904,628981,194268,487428,904769,687021,461349,554158,518438,758613,49084,251188,883638,111175,1023799,317557,1015304,674644,52731,180374,244329,92210,226152,937973,918954,761962,161011,161818,145433,438923,658880,712428,661745,561771,797928,232858,141181,813242,465452,949631,10488,1016131,945303,417430,192200,228888,542523,813871,360930,1030493,95340,886401,322069,870036,72786,416107,491504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]