SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414727 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414727 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77674,890908,875301,506141,284630,717986,435552,317352,585023,183423,57029,439167,261496,1039642,372503,607734,459459,1034908,605016,388676,172393,250573,939307,96433,93659,524670,998236,899333,231718,177131,494029,263828,649956,3209,95281,867427,618652,825071,152746,776814,210536,913239,631597,27356,218370,637217,637986,696753,901512,34122,523254,442085,369039,942086,706117,485232,362704,660650,689784,654140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]