SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312052 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312052 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983030,661778,743008,707639,604532,658522,913442,976309,1003449,685393,479666,1026086,93312,290155,208960,382512,1041989,606662,635163,105,322935,539850,783591,772511,751514,724601,935271,427038,289097,725583,441607,904082,1017500,280987,709724,475620,55869,377557,463206,472839,475720,123593,191527,704388,1011245,290070,70248,310833,908824,826421,847642,878049,832916,310819,527848,437922,821183,409168,103829,944134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001256s ]