SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495569 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495569 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526146,89903,157849,410402,1006500,106834,943013,513519,311218,303580,601634,958983,454831,133182,300110,1006082,19186,328199,927598,320307,325301,774381,410825,275128,602389,666769,430622,851753,401677,549748,478949,800625,35450,1004937,344500,546314,808213,1027842,173001,263110,871826,859618,350419,384281,487020,308252,988082,122069,536188,279134,204617,783667,946710,69522,935571,993993,314504,692940,991836,834849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]