SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 618012 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 618012 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265711,1039219,888656,1004713,164460,550869,427724,572190,238747,550604,110475,458014,962811,728283,8745,663243,258216,1001315,1044051,34622,592777,883955,818900,8676,568417,655331,981147,147376,639045,89750,16675,929849,1008888,382532,59975,374856,27629,84190,847469,789989,323061,331112,740937,230988,342425,979587,513309,131961,867501,945210,963390,1013656,429518,281042,931055,911738,538145,942951,433968,317720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 618012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 618012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]