SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474236 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474236 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621880,589783,700419,422638,370771,134593,818531,1040404,1037287,505203,208407,171066,853370,932292,840040,182007,730244,287613,862585,426784,438627,209440,762319,408710,164153,1021248,897353,929359,654274,502681,73091,82203,471340,894035,776155,790719,483183,104244,863021,690157,225409,465138,457513,696463,768439,851235,3327,771042,207674,500600,519421,13254,887541,869483,936177,885134,708439,850285,568004,1040252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]