SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428311 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428311 [ RunTime:0.006699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048659,1008182,1048212,487799,599782,105802,104122,726356,236754,606385,362873,344407,283956,338255,311070,679221,794297,254963,818413,129525,174401,847854,154940,611302,105655,476384,812385,261859,37907,312844,617414,695656,677146,881188,950161,734567,68003,330726,400573,971804,101488,739569,510131,97886,898043,862338,632770,592422,194386,805559,885345,753633,853573,1027878,64357,306750,758638,906076,525274,396448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]