SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40195 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40195 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844730,439149,279843,348893,477452,484754,445024,164764,810633,45221,233772,757157,237605,153452,616321,413478,488572,1014117,990894,1006978,187508,943832,936617,971355,189786,67686,22011,580503,649133,878137,10128,47858,416220,363651,215862,154716,466860,758714,1034459,324316,144752,783167,535302,78962,467494,85494,1035818,696517,228094,110780,178218,77574,902618,338610,247967,494488,929445,178578,652890,869097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]