SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 935380 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 935380 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820794,369898,793055,664147,403161,33300,462446,258025,176977,106489,552690,437519,911442,247196,26921,922264,204495,859161,415015,618492,568458,533743,638508,966459,883226,193860,181640,224692,678224,804439,737218,567388,854924,43576,671394,654764,486964,63177,949834,709109,130353,313710,1010289,774175,39179,616611,127634,499984,29280,580070,37663,991143,500196,61111,610101,683550,242929,467027,710828,532819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 935380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 935380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]