SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813591 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813591 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624028,91173,546997,300111,158617,1046909,55009,837153,23292,894859,169728,110426,314623,531273,966163,978271,287133,952096,297170,757334,943296,279944,668004,967800,767653,856376,578410,352039,916605,108552,452025,201761,372274,812849,896844,550674,489148,539504,75327,839568,845088,15751,218565,327731,255421,800136,323089,355497,103936,163774,652332,81427,642228,23271,129369,84493,505707,979570,924925,1035795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]