SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448421 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448421 [ RunTime:0.002793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18238,177846,533722,198100,459052,954845,38751,58082,439262,162302,401309,122758,736445,382214,382902,33324,755911,85471,758494,616828,194042,804680,974384,827100,543729,945498,3873,991808,486444,611412,358889,999901,38025,84639,568641,795379,126763,228882,24656,488869,931496,121924,723131,810348,35091,654166,773452,123260,160972,528230,700456,721351,365346,177514,165740,541060,583928,159846,283680,148794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]