SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34601 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34601 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244470,234856,639262,57483,82624,254014,1020523,330002,174686,970513,142035,448817,58268,649310,328874,65879,37544,134248,847721,918067,281770,892208,319274,763258,513422,361714,388566,872680,421556,256217,284166,1046641,373924,169161,712402,179887,127709,146100,661789,439169,967193,740944,859761,259948,115098,179550,781600,670322,861703,657163,627478,72959,322020,243592,784096,321794,60435,221547,817098,1000734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]