SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545212 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545212 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663947,520398,696897,1031791,112356,900846,449234,585348,38921,502176,795802,140470,333012,354769,788144,729104,186652,705930,351362,735953,957046,664500,837599,52999,662643,412760,496806,408387,545453,818958,272096,55182,399048,132983,423833,93581,711092,523013,864733,588653,383599,693596,871119,29232,901863,48331,851575,164448,522118,476615,97725,601083,561246,80083,197701,388604,960862,705731,519435,457043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]