SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101308 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101308 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036893,513545,714952,238940,485257,96329,661097,761532,903651,843265,781438,17850,56324,86883,350953,488725,905438,416417,353801,453916,831204,782118,403421,417069,377417,430758,215311,800909,814625,1039725,324345,223558,192383,881273,877044,40544,847148,492321,456730,167997,588577,428558,559315,822198,459677,159788,712403,482706,452523,388823,640231,1027339,680036,597200,452011,631705,425004,797672,814924,210969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]