SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520113 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520113 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175213,778280,922066,384738,333785,950950,858254,240943,299714,1047677,646234,509756,431086,456173,584852,494862,947031,861588,376838,116659,175121,356640,208274,126779,395326,457945,714960,941318,642058,305765,375468,152580,112340,455366,863115,689697,193454,14460,693637,807424,269959,430312,90283,555881,727197,77321,882831,791893,398461,905883,590680,779045,73899,41901,803288,106372,654716,180160,503369,824023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]