SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033553 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033553 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919239,292106,886146,978261,198925,773109,678008,587426,743467,820352,644600,332342,106416,600434,93522,503462,583201,406491,533200,293148,318701,722626,355355,965202,642821,930416,467831,376880,803748,811772,930697,603459,849797,483783,168451,978764,1011468,453201,1022498,204145,912913,817937,177195,245886,525965,185675,94240,33628,842975,257609,79829,473365,26220,472619,62746,567190,293080,657304,957925,251098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002240s ]