SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425151 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425151 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651187,473596,400434,352562,845752,943704,537018,58590,980481,988769,726389,690551,399559,482656,945851,163589,106923,305682,88819,709669,460449,39495,627658,354393,183055,783840,207273,840161,7819,539841,340552,962830,702979,821839,856028,547121,411322,616408,100212,992439,247196,520551,99746,646828,124420,667214,774069,717831,73832,245964,383771,940361,1029614,294426,409080,319167,297275,503199,221187,616407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]