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` = 381113 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381113 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76999,150542,218870,142945,285254,314313,852859,445701,704410,391006,845530,385473,513348,310554,876192,379135,78842,434256,774283,532034,800786,384160,82684,785373,171696,1006496,228863,820038,107557,498664,946795,800498,310551,400153,288494,717217,238673,641716,346425,485245,771008,659601,615771,1044367,914611,250029,711065,776295,1047285,955259,47523,371548,454343,382047,1016094,323788,474468,165944,527100,704163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]