SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286043 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286043 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026373,891853,1005164,100109,1041677,574146,576546,285157,631569,389258,551092,452430,967471,535372,633600,995345,172439,113109,629005,574847,673486,821156,123443,911195,237865,453718,332546,431757,796397,870179,66279,1013035,885080,922053,772335,691957,273163,507400,985028,31533,601392,944036,746631,783663,269904,712612,214160,704808,75394,926684,493017,426365,696335,29793,105586,307368,828481,592702,578345,987644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]