SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582144 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582144 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433829,791744,196276,150544,508376,555925,22329,91856,703389,926151,103685,776858,1021148,729303,361133,892472,751577,131402,435868,556635,1005868,639639,875422,425032,929300,792854,134335,451713,828073,171653,364347,491619,506746,186955,621125,654871,225489,904788,496622,835217,943584,920037,780006,862582,942095,193475,564621,66475,821170,517193,181190,658582,727213,624504,700668,1023675,886927,997150,385718,920266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]