SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146726 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146726 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510093,800388,119700,988321,289301,590594,85055,703774,96193,245363,357701,47669,7521,481853,783404,938314,848817,262089,190896,174606,290522,383130,994895,803083,599611,452056,28357,712794,304619,916148,977180,33804,910180,174880,253358,113565,210954,474100,368658,997887,99077,889068,286035,154548,571571,284261,253593,1014659,50020,208115,167155,12109,737442,896302,271268,724737,1016067,856447,84420,26889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]