SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455628 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455628 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392448,732313,512693,55498,30364,34662,923780,63541,152660,557841,158875,599433,719747,669672,858116,811597,900769,675086,724877,1288,944318,414122,709385,598449,53408,466697,147838,661320,563479,994664,301125,363872,951496,705271,574772,297950,977891,771346,7780,570775,457374,376774,657036,701026,550763,470284,202961,918659,43533,199040,601471,871375,927303,917770,274340,217280,1032899,666713,517715,639005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]