SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50449 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50449 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459769,62900,536093,243285,557899,500199,605702,998479,673204,974073,55474,961169,84896,1005449,536376,506294,930719,307953,97470,474160,546195,25289,325438,458750,341484,963099,401315,626362,730350,443289,448994,866012,506904,116330,205008,605093,513562,204324,1045982,224935,423698,207847,1012174,71742,38362,709135,590806,875887,386640,805539,758434,52501,623948,1042283,120718,233762,386371,624817,734542,632955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]