SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485874 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485874 [ RunTime:0.002041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290725,1015356,117687,917447,4535,55627,198201,391686,792002,741780,408760,378061,838543,24492,304349,619567,185222,316272,39560,934803,657695,293825,988885,340271,645960,824476,415050,491651,493085,540238,78191,900828,776591,809918,352551,684862,682497,975597,720125,552714,638670,755128,754055,541431,304397,977411,377747,419801,569661,444418,206886,579735,777091,469193,123467,348349,305313,461450,467769,983328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]