SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30081 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30081 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61319,948187,1013151,522719,510903,1015696,922307,799294,146445,834224,376504,804503,771654,803387,986186,584714,934314,327034,123936,787499,540269,57402,196894,204596,493246,853336,631225,109372,303767,259714,964614,464133,700843,373832,205818,137474,873916,358675,696062,693378,963235,370413,492300,128327,1031201,1037351,39151,230984,879456,644740,176441,747989,503147,426390,690471,671531,982779,490699,489653,130147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]