SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914918 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914918 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918477,927277,437860,788480,470669,66312,494675,288710,591868,350135,404651,828724,220046,817521,1040668,542043,991405,228379,757332,137355,982741,619219,280666,400217,217830,492284,536376,644412,782567,111381,379883,337446,469644,181472,698004,828203,436769,966632,760378,86535,822865,525398,256508,198924,8017,459878,136587,197536,308615,1017760,39065,43504,329037,782638,818875,845701,409098,626930,740239,1034305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]