SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380206 LIMIT 1 [ RunTime:0.000732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380206 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801390,488130,889270,577085,934417,235984,326639,651038,303447,8410,413033,508902,565730,197259,531269,12178,946724,551832,720529,589741,8808,16350,440079,350093,371960,1012502,183491,15605,85218,39294,591095,224723,607144,995836,637354,1014172,1013999,170422,161548,714871,658363,53948,1041096,856174,253836,316535,194825,261720,701270,140159,448576,1005910,344624,457001,785632,904315,1017952,652000,193051,256116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]