SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468303 LIMIT 1 [ RunTime:0.002125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468303 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695903,610270,481982,762559,540930,16262,625085,692408,929515,283039,319674,953124,16191,481387,660034,738818,783538,637071,357685,46732,669384,446768,2163,523045,901737,996814,463680,578496,378449,538276,720398,725275,711815,329729,918006,110887,649348,40727,89214,555139,315023,1046846,836155,125497,1010368,969990,121669,354243,527874,517492,501640,516071,303819,398508,657550,191821,333400,94564,659065,234714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001398s ]