SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291870 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291870 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215057,549476,617833,508855,698421,541488,789665,508518,627153,317066,570974,415694,183135,315271,202790,501439,496222,853684,427412,928709,942041,884148,40927,166571,197480,579198,234074,723125,695435,560136,671844,561018,710264,103596,131681,882171,1029365,463484,438778,585351,595578,744794,484588,809844,860423,374367,418236,377863,938586,405292,1040051,846569,679596,140481,398777,258613,681246,670795,972644,99629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]